SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Tucked away on three private, wooded acres, this charming Cape Cod offers the perfect blend of tranquility and efficient home design. The main level features a nicely proportioned living room, an eat-in kitchen, and a family room with a fireplace, plus a convenient half bath. Upstairs, three bedrooms include a spacious primary suite with a full bath, a study perfect for working from home and an additional three-quarter bath. The finished basement adds even more flexibility with a bonus room ready to become a playroom, home gym, or creative space, along with a three-quarter bath. Recent upgrades include a new roof, exterior paint, heat pump technology for efficient cooling, and updated bathrooms throughout. This is a wonderful place to call home.
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck — ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2–3 bedrooms, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts—this is the ideal year-round lakefront paradise.
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:Set in a highly sought-after location with easy access to town and nearby trails, this beautifully maintained cape blends comfort, functionality, and convenience. An attached 2-car garage and direct entry add to the home’s everyday ease. Inside, the thoughtfully designed layout begins with a spacious mudroom featuring a walk-in closet and half bath—perfect for staying organized year-round. The open-concept kitchen, dining, and living area creates a natural gathering space, ideal for both daily living and entertaining, with a slider leading out to a private back patio. A dedicated home office offers the flexibility today’s buyers are looking for. Upstairs, you’ll find two generously sized bedrooms and a full bath, along with an oversized primary suite. This inviting retreat features a walk-in closet and an en-suite bath complete with a soaking tub. Convenient second-floor laundry enhances the home’s practical design. The finished lower level provides additional living space with a large family room and full window—perfect for guests, a media room, or a cozy place to unwind. A utility room offers excellent storage or the potential for a small workshop. All of this is just minutes from Dartmouth College and within 10 minutes of Dartmouth-Hitchcock Medical Center. With a level, low-maintenance yard and well manicured perennial gardens, and a location that balances accessibility with outdoor recreation, this home delivers the best of Upper Valley living.